Skip to main content

TEMP TABLE TRANSFORMATION

Short Description

A temporary table is being created or used for this query.

Detailed Description​

Oracle uses a temporary table (in memory if possible) to transform data from further down the plan. This can be seen in WITH (Common Table Expression - CTE) queries where it is materializing result sets.

Further Reading​

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.